Easy Exporting of Results to Excel?*

[nick garza]

Hey all,

I am getting a little frustrated I basically have hundreds of cross tabs that I need to put into excel tables. Ideally, I could export them to excel and reformat how I need them in Excel, pretty easily. Or at the very least, copy paste my results into excel. I am learning about about putexcel - but it seems like it wants to almost build the formatting in my stata commands, but this seems needlessly time consuming to specify cells and whatnot. I am hoping that I am just missing something and there is an easier way to export results into excel and have STATA just make a lot of those decisions that I can clean up later. Any tips?

Tbanks!

[Fei Wang]

To my understanding, Stata (or any non-AI software) cannot make decisions for you - They all loyally implement what you ask them to do under specific code. Quite a few commands (e.g., the new table command in Stata 17), including the ones written by experienced users, can design the layout of tables, but they may not flexibly meet all requirements of users. I agree with you that it's a bit tedious to outline tables with endless lines of code, and I often copy and paste if there are only several tables. But if you have a huge set of similar tables, or need to tabulate many times, it may be worth spending some time at the beginning to save life from repeated copy and paste.